The DATASETS and DELETE procedures might fail to delete a Google BigQuery view, and an error that is similar to the following appears:

The only workaround is to use an explicit SQL query. Here is an example:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Google BigQuery	Linux for x64	9.4	9.43	9.4 TS1M6	9.4 TS1M8

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates

---

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#67539

---

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#67539

---

PROC DATASETS and PROC DELETE might display an error when attempting to delete a Google BigQuery view. The message is "Error 400: Cannot drop gcp-project:data-set.view-name which has type view. A table was expected."

Type:	Problem Note
Priority:	high
Topic:	SAS Reference ==> Procedures ==> DATASETS SAS Reference ==> Procedures ==> DELETE SAS Reference ==> Procedures ==> SQL

Date Modified:	2021-04-13 10:29:34
Date Created:	2021-03-03 05:56:43